Replies

ok this might help… here is the actual code I’m using:
Sub Get12()
Dim LastCol As Long
LastCol = Worksheets(“data entry”).Range(“IV3”).End(xlToLeft).Column + 1
Worksheets(“Sheet1”).[A2:A13].Copy Destination:=Worksheets(“data entry”).Cells(3, LastCol)
End Sub

now I need to be able to check colum+1 against last column to ensure I don’t have two colums with the exact same data in them. If it is the same data I need to inform user that the data is the same data from yesterday (last column).

how do I do this in excel????

ok this might help… here is the actual code I’m using:
Sub Get12()
Dim LastCol As Long
LastCol = Worksheets(“data entry”).Range(“IV3”).End(xlToLeft).Column + 1
Worksheets(“Sheet1”).[A2:A13].Copy Destination:=Worksheets(“data entry”).Cells(3, LastCol)
End Sub

now I need to be able to check colum+1 against last column to ensure I don’t have two colums with the exact same data in them. If it is the same data I need to inform user that the data is the same data from yesterday (last column).

how do I do this in excel????

sd you hit it on the head…. thats exactly what I want to do (your second idea). But how /where do I put this in my macro. Do I need to add it to each cell. or can I edit my macro and put it at the top or bottom… I’m totally unsure of this… and by the way thank you a million times over for all your assistance and those of the panel…

sd you hit it on the head…. thats exactly what I want to do (your second idea). But how /where do I put this in my macro. Do I need to add it to each cell. or can I edit my macro and put it at the top or bottom… I’m totally unsure of this… and by the way thank you a million times over for all your assistance and those of the panel…

one more time guys,,, here is a copy of the actual spreadsheet . the column A has all times. this reflects the time the jobs on ibm run. the headings have the date for the different days that it runs (through the end of the year).
St. Louis
3-Apr 4-Apr 5-Apr 6-Apr 7-Apr 8-Apr 9-Apr 10-Apr
3:00 40
3:30 67
4:00 72
4:30 62
5:00 49
5:30 79
6:00 91
6:30 285
7:00 321
7:30 196
8:00 253

total jobs 1515 0 0 0 0 0 0 0

this next data is the imported data from the text file that goes into a different sheet (say sheet 2) also found in column b above
40
67
72
62
49
79
91
285
321
196
253
this gets updated evey day same column same rows, Once its updated I then run the following macro to bring the data to sheet 1 (the first sheet above).
Sub Macro1()
‘
‘ Macro1 Macro
‘ Macro recorded 4/20/2004 by Compaq
‘

‘
Range(“BL3”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R1C1”
Range(“BL4”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R2C1”
Range(“BL5”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R3C1”
Range(“BL6”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL7”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL8”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL9”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL10”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL11”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL12”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL13”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL16”).Select
Application.CommandBars(“Stop Recording”).Visible = False
End Sub

I now need to know how to make the data go from column b to c to d etc… every day I open the new data. keep in mind the imported data column A rows 1-12 on sheet 2 never changes just the data does.
also where in my macro would I put the new macro (If you guys havent noticed by now I’m some what a newbe at this) do I have to use your macro in every cell or do I put it in the code up abaove? please help time is running out.

one more time guys,,, here is a copy of the actual spreadsheet . the column A has all times. this reflects the time the jobs on ibm run. the headings have the date for the different days that it runs (through the end of the year).
St. Louis
3-Apr 4-Apr 5-Apr 6-Apr 7-Apr 8-Apr 9-Apr 10-Apr
3:00 40
3:30 67
4:00 72
4:30 62
5:00 49
5:30 79
6:00 91
6:30 285
7:00 321
7:30 196
8:00 253

total jobs 1515 0 0 0 0 0 0 0

this next data is the imported data from the text file that goes into a different sheet (say sheet 2) also found in column b above
40
67
72
62
49
79
91
285
321
196
253
this gets updated evey day same column same rows, Once its updated I then run the following macro to bring the data to sheet 1 (the first sheet above).
Sub Macro1()
‘
‘ Macro1 Macro
‘ Macro recorded 4/20/2004 by Compaq
‘

‘
Range(“BL3”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R1C1”
Range(“BL4”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R2C1”
Range(“BL5”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R3C1”
Range(“BL6”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL7”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL8”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL9”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL10”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL11”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL12”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL13”).Select
ActiveCell.FormulaR1C1 = “=Sheet1!R[-2]C1”
Range(“BL16”).Select
Application.CommandBars(“Stop Recording”).Visible = False
End Sub

I now need to know how to make the data go from column b to c to d etc… every day I open the new data. keep in mind the imported data column A rows 1-12 on sheet 2 never changes just the data does.
also where in my macro would I put the new macro (If you guys havent noticed by now I’m some what a newbe at this) do I have to use your macro in every cell or do I put it in the code up abaove? please help time is running out.

the date was already inputted by the manager unsure of how he put it there. i just need a simple macro that will update the next column with the same row of data as input from the sheet that had imported my text file. when I open my spreedsheet now every time I open it my text file has different data but that data is in the same column and rows column A rows 1-12. what I need is something that will take that data and put it in the next available column on another sheet that my text file is not imported into.

the date was already inputted by the manager unsure of how he put it there. i just need a simple macro that will update the next column with the same row of data as input from the sheet that had imported my text file. when I open my spreedsheet now every time I open it my text file has different data but that data is in the same column and rows column A rows 1-12. what I need is something that will take that data and put it in the next available column on another sheet that my text file is not imported into.

ok here are the basics. I need to keep track of how many jobs are running within the ibm queue at a certain hour of the day (12 hours a day – hence rows 1 through 12). I need to do this every day until the end of this year (hence the dates). But I need the most current date in the column on the right. anotherwords… 5-april, 6-april, 7-april etc… I hope this gives you guys a better understanding.

ok here are the basics. I need to keep track of how many jobs are running within the ibm queue at a certain hour of the day (12 hours a day – hence rows 1 through 12). I need to do this every day until the end of this year (hence the dates). But I need the most current date in the column on the right. anotherwords… 5-april, 6-april, 7-april etc… I hope this gives you guys a better understanding.

ok, first of all thanks for replying to my post. here is my situation…..
1).I have a program/job on an ibm mainframe that strips data from a file – it then creates a new file called FILEA.
2). I then take FILEA and ftp the file into a text file – called FILEB
3). I created an excell spreadsheet with two different sheets (sheet1 & sheet2).
4). I imported FILEB into sheet1 (all this has is one column 12 rows – all data numeric – no headings)
5). I then wrote a macro on sheet2 to bring in the data from the individual cells on sheet1 to their corresponding cells on sheet2
6). Sheet2 consists of headers of dates from column A through column XXXXX.
7). I need a macro that will take my daily updated information on sheet1 and put it in the individual columns on sheet2 daily.

sheet1
—————————
2 |
————————— <——– data gets updated every day from program on ibm. so text file gets updated, which means sheet1 gets updated.
3 |
————————–
27|
————————–

_5-apr___|____6-apr__|___7-apr__|__8-apr__|__9-apr__|_etc….
2 | 54 | 73 |
———————————|————————- <——– new daily data gets applied to new columns from ibm job/text file/sheet1s (same columnA rows1-12).
3 | 8 | 2 |
———————————| ————————
27 | 34 | 123 |
————————————————————

so can anybody help…

ok, first of all thanks for replying to my post. here is my situation…..
1).I have a program/job on an ibm mainframe that strips data from a file – it then creates a new file called FILEA.
2). I then take FILEA and ftp the file into a text file – called FILEB
3). I created an excell spreadsheet with two different sheets (sheet1 & sheet2).
4). I imported FILEB into sheet1 (all this has is one column 12 rows – all data numeric – no headings)
5). I then wrote a macro on sheet2 to bring in the data from the individual cells on sheet1 to their corresponding cells on sheet2
6). Sheet2 consists of headers of dates from column A through column XXXXX.
7). I need a macro that will take my daily updated information on sheet1 and put it in the individual columns on sheet2 daily.

sheet1
—————————
2 |
————————— <——– data gets updated every day from program on ibm. so text file gets updated, which means sheet1 gets updated.
3 |
————————–
27|
————————–

_5-apr___|____6-apr__|___7-apr__|__8-apr__|__9-apr__|_etc….
2 | 54 | 73 |
———————————|————————- <——– new daily data gets applied to new columns from ibm job/text file/sheet1s (same columnA rows1-12).
3 | 8 | 2 |
———————————| ————————
27 | 34 | 123 |
————————————————————

so can anybody help…