Hi Experts,
I wondering if there is a way to create a macro that takes data from an active sheet and inserts it into a table on a new sheet?
Thanks in advance!
Hi Experts,
I wondering if there is a way to create a macro that takes data from an active sheet and inserts it into a table on a new sheet?
Thanks in advance!
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Manually add exactly what you want to see on another sheet.
It may be the case that a Pivot Table will give you what you want.
Incidentally would you add your location please. This is often useful where regional list separators/dates/time zones are involved
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks