I have a file with 3 tabs. The tab called "Exported_Data" receive data tab labeled "Register", based on the criteria tab "Summary". See the result that was done manually and that I need to get n tab "Exported_Data" Thank you!Desfazer edições
I have a file with 3 tabs. The tab called "Exported_Data" receive data tab labeled "Register", based on the criteria tab "Summary". See the result that was done manually and that I need to get n tab "Exported_Data" Thank you!Desfazer edições
Last edited by marreco; 06-05-2012 at 07:36 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
I think this is what you are after. Formula starting in cell A10 of exported data.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
I'm sorry but I'm changing the formula to VBA as the original spreadsheet, I have many lines, it is very heavy, if someone could me judar with VBA, I am grateful!
Hi.
Any idea?
Thank you!!
Hello people.
anyone have any idea how to do for VBA?
Thank you!
Should the exported_data tab have formulae only in as many rows as the Summary sheet?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Who in this case the column "A" is my criteria, but should follow the guide to "Exported_Data", column "A" and "B" tab "Summary".
It is exactly what makes the Dunc3142 did! But I need via VBA.
Yes, when you do it via formula, you can just drag down the answer to how many ever rows you need.
But when you are doing it through VBA, you need to tell the code for how many rows you want the formulae to be input.
So your summary tab shows 5 rows, does that mean your exported_data tab should also have the formulae for 5 rows?
Hi.
yes!!..........
Use this codePut the code in a standard module.Please Login or Register to view this content.
The formula that was given to you was only considering row 10 of the Cadastre sheet. I have made it variable, so it will consider how many ever rows are there.
The formulae in the exported_data sheet will be input, then paste special values and the date format applied to columns E & F.
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks