Forum Discussion
Writing Macros in Excel
Hi Bigtoes,
I am not sure I understand fully. By "Row A" you meant row 1, correct? I am assuming you did.
For sheet 1, you put the date in the A column, and based on the fact it has a date, when you press "go" you want it to take the amounts in different cells and add them to the cell in F, then transfer that to a cell on sheet 4. Correct? Are all the amounts to be added in the same row? After the macro would run, what happens to the date on sheet 1? If you run the macro again, where would the next total be placed? Below the last one? On sheet 1, is there a column that has unique entries, like a part number or a name that is used only once?
If there is a unique identifier column on sheet 1 you may be able to do this with formulas.
- The dates, as in the day number (1,2,3...), are down column A from cell 2-32 and A1is labeled Date. Along the top row (Row 1), from B-M are the names of the months. That is all on Sheet 4. Column A on Sheet 1 is for a formatted date, ie: 01/01. The revenue from that date is recorded in Column F. The macro I need to create involves having the correct date and all of the dollar ampunts from a particular date. It would need to recognize a particular date for at. It would also need to add all of the dollar amounts from any day indicared by that format. The information would then be totaled and put in the proper cell on Sheet 4.
- Are you able to provide a sample of the spreadsheet?
SqueakySneakersHere is a copy of the spreadsheet I'm working with. I have actual data that I need to assimilate. I just need to be pointed ion a direction that will allow me to transfer data between sheets as it's entered, instead of having to hit shortcut keys.
