I have a workbook with 3 tabs. Right now, I am working to make this a template that I can import 3 csv files into for a given report.
What I lack is a way to make this automated. I set this up with a small set of data. Each tab has the follow standard format: + First row has headers + A totals row with formulas + First set of columns is for data, subsequent has formulas. So on one tab I have 2 rows of 'test' data(below header row), which fills columns A:H. Then I:N has formulas that calculate information about the stuff in columns A:H. Row 4 has totals, which are not necessarily just a sum formula (one converts KB,MB and GB sizes). So this is what I am trying to do. I want to make a macro that will prompt for a CSV file. Then I want the data to import starting at A2, replacing that row of crap data, and replacing the data in row 3 as well. Then it needs to shift row 4 down enough to bring in the rest of the data. Finally, I need to copy the forumlas in I:N down for as many rows as there are, and retain the totals formulas in M and N that were on row 4. I am wondering if anyone might have any help on the beginnings of a macro to help me automate this. I have 2 other tabs, but the only difference with them is which columns have data to be replaced and the amount of columns. If I can get 1 to work, the others I know I can figure out. Any help is greatly appreciated! --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
