Excel tips create numbers 1 to 10

Hi,

I would like to create a new products numbers column in Excel.

I have my supplier "SKU's numbers" in column A , I would like to create my "SKU's numbers" in XXXX format (only numbers) in column B.

Could someone help me pls todo it with Macro or if it possible todo it in formula ?

The code should check in the excel sheet, that it is not generate a new SKU that was used before !

Any help please? Thanks a lot,

Eli

basically i need to create a graph to put into my lecture notes. i was trying to do it in paint but i figured excel might make it more neatly.

i want a normal x and y axis shown, but also on the x axis i want it depicted where the 5% and 10% marks are. (i'd prolly want the corresponding data labelled on the y axis as well). then there's 2 lines which connect the corresponding x and y data (see attached diagram) - in paint i made that a solid line but i actually want it to be dotted.

im sure this is possible in excel but i cant figure out how. can anyone advise?

thanks!
dan

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

I am trying to write a macro/VBA that looks at A1, A2, and A3, where A1= starting number, A2=the range, and A3=the number of iterations. If A1=1, A2=4, and A3=3, I want to fill B1 with:
1
2
3
4
1
2
3
4
1
2
3
4

I have this so far:
Sub filler()
Dim length
Dim start
Dim iterations
start = Worksheets("Sheet1").Cells(1, "A").Value
MsgBox (start)
length = Worksheets("Sheet1").Cells(2, "A").Value
MsgBox (length)
iterations = Worksheets("Sheet1").Cells(3, "A").Value
MsgBox (iterations)
Range("B1") = start
Range("B1").DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, _
step:=start, Stop:=start * length, Trend:=False
End Sub

If you have any tips or tutorials that you would like to see, or add to
my blog, please visit me at http://teachr.blogspot.com and let me know.

Hi Everyone,

Do you guys have a site similar to the site the word folks have below for
creating and manipulating pivot tables? We would like to learn how to
create pivot tables in excel 2000, we will soon be getting Office 2003 but
will be keeping 2000 also. We also have some money in the budget for some
books. Do you have any recomendations? We work in the medical field so are
not computer geeks yet so we need books that are geared towards non
programmers. Our excel use is mainly for tracking outcomes and not a lot of
heavy math. I have a couple of database books that were recommended for
using Access from the Access group. One is Access 2000 from QUE and
Database design for mere mortals was another and both have helped out alot.
We would like books similar but for Excel.

http://www.word.mvps.org/FAQs/Format...ingColumns.htm

Thanks,
Linda

I'm currently working on a new Excel Tips and Tutorials Blog for
beginners, intermediate and advanced users alike. I need some ideas
for common problems or tips that people request on newsgroups and
searches on the internet etc.

If you could please suggest some ideas to me that I can write tutorials
for and therefore add content to my blog with I would be grateful.
Please email any ideas or previous problems you have had to
mattyboy150279@gmail.com and I will add them to my site with detailed
solutions.

My site is http://teachr.blogspot.com

Many thanks in advance.
Mat