Hi,
I have a problem.
I have a vba macro to download data from one table in excel sheet to new excel file.
Now in first file I have two tables in the same sheet i I need to have macro to download both tables in one new excel file in one spreedsheet.
Please Login or Register to view this content.
I tried to create similar macro
but I dont know how to connect this two macros in one.Please Login or Register to view this content.
Could you please help me?
thanks in advanced
N.
Last edited by nawalanek1; 03-07-2023 at 12:11 PM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks Glenn for your clarification.
Thread open again... Thanks!!
see if this works
Please Login or Register to view this content.
Thanks k1dr0ck,
Unfortunately not works.
Please find attached screenshot with error.
Br
N.Attachment 8207012.JPG
try
Please Login or Register to view this content.
Last edited by k1dr0ck; 03-08-2023 at 09:16 AM.
Hi k1dr0ck
Please check attached example.
When I click button Generate I see data from Table 2 in separate excel file.
My goal is how to have a both tables( 1 and 2) in this excel file.
Thanks for your help!
Br
N.
see post #7
Unfortunately Attachment 820764
Hi,
k1dr0ck
sorry for confusing date. I know error. One from two tables from original file is Pivot table - this is the reason that macro is showing only one table.
Is it possible to correct this macro if it works with one table and one pivot table?
apologies again
Br
N.
in your attached there are two tables already, if you link the button to my sub procedure it will copy the two tables to another new workbook, it will look for "Table1" first copy then paste to new workbook then look for the next table, is that what you wanted?
yes but one of this tables is pivot table. Macro is downlead only Table 2, pivot table not. I want to download both tables.
Please check attached file.
try
it will copy the tables first then the pivot tables
Please Login or Register to view this content.
works properly, Thanks!
PS. Is it possibly to have in resulting file data from pivot table in regular table ? not pivot. - macro copy data from Pivot table and put this data to regular(not pivot) table?
Last edited by nawalanek1; 03-09-2023 at 08:56 AM.
in attach to above post. Attachment 820963
Attachment 820964
try
Please Login or Register to view this content.
works
last question, is it possible to keep cells formatting from original file?
ex. in original file value is 50% in final file 0,50.
unfortunately the code paste the pivot table as values to convert it to a regular table
maybe someone has knowledge to convert a pivot table to a regular table and retain formatting
ok, Thank you!
I have been playing with other ways to merge tables and pivot table data etc. It will not help you with your formatting issue as the below will also create values only and not carry any formatting over. Thought i would share what i had been playing with:
Please Login or Register to view this content.
If things don't change they stay the same
Thanks CheeseSandwich!
br
N.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks