I have a code that copies over to the new sheet, but I need to adjust it to copy the formula down.
E4 & G4 are headers
Please Login or Register to view this content.
E5 & G5 are the formulas that need to autofill down.
Can someone help adjust my Range
Copy the data into an Excel Table. Duplicating formulas down is one of the things Excel Tables do.
Here's an introduction to Excel Tables: http://www.utteraccess.com/wiki/inde...ables_in_Excel.
If you decide to go this route, here's a handy routine to clear out old data in a table.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thank you, I am just trying to incorporate my above code into an existing one. There is probably a better way, but I didn't want to cause too much hassle. The below code is something I garnished from another website and have frankensteined it to work for my uses. As you can see at the very bottom is the code I posted initially. Can that be adjusted so that I can incorporate it into my big ugly code?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks