S
Scott Campbell
Thank you to everyone for there help in the past. I have found this forum
very helpful and have recommended it to dozens of people.
My latest project requires my to do a simple cut/paste to multiple
worksheets and fill down.
Here are the details.
The first 8 rows of each sheet would be header information
Row 9 -->??? contains the actual data.
This data is contained in columns A:M
Starting in Column P9:Z9, I have created formulas that retrieve data from
the header and body.
P9 --> =$F$1
Q9 --> =$F$4
R9 --> =$F$3
S9 --> = $C$9
T9 --> = trim(C9)
U9 --> = D9
V9 --> = E9
W9 --> = $j$9
X9 --> = trim(J9)
Y9 --> = K9
Z9 --> = L9
No problem so far. When these formulas are fill down the $ stay constant.
So, after all of that here is what I need to do:
I would like to take the formulas found in p9:Z9 and copy to each worksheet
for all rows that contain data (after row 9)
Each workbook could contain any number of worksheets
and each worksheet can contain any number of records (rows).
I would like to create a macro to perform this task.
Any help is appreciated.
Thanks
Scott
very helpful and have recommended it to dozens of people.
My latest project requires my to do a simple cut/paste to multiple
worksheets and fill down.
Here are the details.
The first 8 rows of each sheet would be header information
Row 9 -->??? contains the actual data.
This data is contained in columns A:M
Starting in Column P9:Z9, I have created formulas that retrieve data from
the header and body.
P9 --> =$F$1
Q9 --> =$F$4
R9 --> =$F$3
S9 --> = $C$9
T9 --> = trim(C9)
U9 --> = D9
V9 --> = E9
W9 --> = $j$9
X9 --> = trim(J9)
Y9 --> = K9
Z9 --> = L9
No problem so far. When these formulas are fill down the $ stay constant.
So, after all of that here is what I need to do:
I would like to take the formulas found in p9:Z9 and copy to each worksheet
for all rows that contain data (after row 9)
Each workbook could contain any number of worksheets
and each worksheet can contain any number of records (rows).
I would like to create a macro to perform this task.
Any help is appreciated.
Thanks
Scott