Need help with my code below. i am trying to build a macro that copies data from sheet2 and pastes into queue performance but nothing is being pasted in?i.e values arnt working
Please Login or Register to view this content.
Need help with my code below. i am trying to build a macro that copies data from sheet2 and pastes into queue performance but nothing is being pasted in?i.e values arnt working
Please Login or Register to view this content.
Try changing
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Or, instead, change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Hi, that code works but it is not putting the data into the correct cells.
I want the data to start populating from "B4" onwards but it skips to column X.
The previous columns B4 to W24 do not have any data in them except for some formatting.
Any ideas
Hi,
It may be that you need to change the row that you use to search for the last column.
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi , No that doesnt work either. i have attached the file i am using , could you see if you could see the problem.
I want the data from sheet 2 to be pasted into queue performance sheet starting in G4 which is todays day and continue on to the next colume for the next day.
At the moment the macro seems to think most of the colums are filled and is skipping to colume x.
As well, the data needs to be entered from the 4th row down however it is beginning in the 1st and is overriding the date heading and then the last few rows have no data
Last edited by dee2016; 08-05-2016 at 07:18 AM.
You didn't mention anything about locating today's date. You merely said that you wanted the data pasted to the next column.
It also seems that you are sending the data to a range starting at row 1 which is not what you want. May I suggest this:
Please Login or Register to view this content.
Last edited by xlnitwit; 08-05-2016 at 07:26 AM.
Hi man, sorry i thought it wouldn't matter if the date was there but i see where you're coming from now, that solution seems to work well.
could it be possible for you to add comments around the code so i can understand fully what each statment is doing please
Certainly. Please see below.
Note I made a small change to the code to simplify it in case you should wish to change the output location.Please Login or Register to view this content.
Thats great thank you,
If you go into the file I attached earlier, row 10 is actually used to sum up the rows above it, is it possible to incorporate this into the macro because at the moment that row is left blank ?
Of course. All you need add is this:
Please Login or Register to view this content.
Works perfectly, what exactly is it doing?
It adds a formula to sum from row 4, or whichever row is set as the start of the output, to the row above the formula cell.
Thank you, I have an issue with the code,
This part
the name of the workbook changes every month i.e August changes to September and so on.Please Login or Register to view this content.
Would it be possible to make the macro work on the active workbook it is open in at that time?
Otherwise the detail in the macro code will have to be changed every month
Thank you
If the macro is in the workbook to which you want to refer, use ThisWorkbook.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks