Good Afternoon
Im looking for a macro that will copy a column from one spreadsheet to ther based on the data in the top cell
Any help with this would be much apreciated
Thanks
Good Afternoon
Im looking for a macro that will copy a column from one spreadsheet to ther based on the data in the top cell
Any help with this would be much apreciated
Thanks
What is the data in the top cell?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
How do you decide which date? Do you want to be prompted for the date or would it work for you if you simply double clicked the date to copy that column to another sheet?
I was thinking if in the spreadsheet that i want to copy the values to i have a cell with a specific date and match with the date in the other sheet
Just to clarify .... In the destination sheet you have a cell with a date. In the source sheet you have dates across row 1. You want to find the date in the destination sheet cell in row 1 of the source sheet and copy that column over to the destination sheet. If this is correct, it would be helpful to know the names of the source and destination sheets and the cell location of the date in the destination sheet.
That is correct
if you highlite in the macro where i will need to put this information i think i can do it myself, is just that my spreadsheet are too big and im not able to upload them
It would be helpful to know the cell location of the date in the destination sheet. Do you want to copy the column at the end of any existing data on the destination sheet?
Try:Please Login or Register to view this content.
Use this macro instead of the previous one. I've made a small change in the code. Change "Sheet1" and "Sheet2" to match the actual names of the sheets that you are using.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks