Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro to cut/paste to last cell
Hello all, and many thanks for previous help. Once again, I am stumped. I
have a worksheet that contains a report and subreport I am exporting from Acess into Excel. The data in the report and subreport are variable (sometimes more, sometimes less). I export the file into Excel, and the subreport portion comes up off to the side below the report portion on the same worksheet (i.e. the report fills up A1:I151, and the sub report fills up J52:M64). I've got enough wherewithal to figure out how to find the last cell with data in it, and to find the cell containing unique data in the subreport to select the 5 or so columns contained in it, just not able to string this all together. The issue here is that since it's all variable, today the report section may end at row 151, and tomorrow it may go to row 250 or only row 50. Additionally, I need to find the last cell of the report section (i.e. A1:I151) with data in it, not the last row with data in it on the whole sheet. I need to be able to A)Find the unique data in the subreport to select the data I need to cut, B)find the last row of the report with data populated in it, C) skip 4 rows and paste the information cut from the subreport section. I'd leave this all in Access, but it's going to a customer who has to have it in Excel. Any help would be most appreciated. -- Best Regards, Beth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
A Macro that will cut and paste to specific cell | Excel Discussion (Misc queries) | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Macro on cell content | New Users to Excel | |||
Macro to sort by cell colour | Excel Worksheet Functions |