Hi,
I have this file attached,where I want a macro to concatenate 2 sheets data into one sheet,one after the other.
Hi,
I have this file attached,where I want a macro to concatenate 2 sheets data into one sheet,one after the other.
Can you elaborate? How do you want them concatenated, A1 on one sheet & A1 on another into A1 on the output sheet ???
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
The 2nd sheet data should be appended at the end(last row populated) of first sheet
Record yourself doing it and then inspect the code. Thats how most people learn. There's nothing else to be said about that one. Its just a cut and paste.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks