Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autopaste data based on correct MO.
Currently, I have a macro that formatts a dataset. But, because the data comes from a text file, then I convert it into excel, the macro runs outside of my summary sheet. I want to be able to bring that data in a seperate file, after the macro runs, into the correct tab. The tabs in the summary sheet are listed by month. Is there a way to write a macro command to paste data into a summary sheet based upon the month (the current macro defines the month at the top of the page). Thanks. -- ineedhelp2 ------------------------------------------------------------------------ ineedhelp2's Profile: http://www.excelforum.com/member.php...o&userid=26298 View this thread: http://www.excelforum.com/showthread...hreadid=400800 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Correct Syntax for Changing Color of Cell Based on Value | Excel Discussion (Misc queries) | |||
Select correct worksheet based on data entered into a cell | Excel Worksheet Functions | |||
Pivot table converts data to a 1,2,3 how do I get data to correct | Excel Discussion (Misc queries) | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
How do I stop the autopaste function in Excel? | Excel Worksheet Functions |