I pull off reports from access and export them to excel, they appear in the format (not the data i pull off, just an example) below and i have to manually fill in all the blanks, does anyone have an idea on how to automate this?
How it looks;
Month Date
Jan 1
2
3
4
5
Feb 1
2
3
4
5
How it should look;
Month Date
Jan 1
Jan 2
Jan 3
Jan 4
Jan 5
Feb 1
Feb 2
Feb 3
Feb 4
Feb 5
Last edited by Josephwat13; 07-28-2015 at 10:50 AM.
This is assuming column "A" contains your data and that it starts in row 1. Change to whatever the column/row actually is.
Please Login or Register to view this content.
Try:-
Regards MickPlease Login or Register to view this content.
Thanks guys!
Mick - I got yours working but I was wondering if i could do it for multiple columns, I have tried moving it around and copying it so it will just repeat the process but I just get errors. any chance you could help with this?
BTW the button is on a different sheet to the data i am sorting
You don't need a macro for that, if you're happier with a macro then by all means, but I do it like this:
Select the full range > f5 (goto) > Alt + S > Enter > Alt + K > Enter
Then in the formula box, =A1 > Control + Enter
Copy, paste special values
Last edited by Kyle123; 07-29-2015 at 04:03 AM.
Do you want it Hard coded to ranges on another sheet .????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks