Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi mate. How can I upload the test file?
You can upload it on wikisend.com and share the link
I will try to download it
I downloaded and opened the sheet
can you please explain your requirement in detail with any example
So lets say we are on sheet 1 and and in column L they are all selected as NO. When we select it to Yes I want the details of row
I want the details of that row to pull through to the master header.
so.. you want details of ALL rows whose L column is Yes from sheets 1,2 & 3 in Master Sheet
as we change the value of column L from Yes to No the row should vanish from Master sheete
similarly if it becomes Yes from No then it should appear in Master sheet
is there any specific order you are looking for in Master sheet.. like first rows from sheet 1, then from sheet 2, then sheet 3
or any order is fine..
Any order is fine at the moment
how long you will be available on the chat?
Let me work on this
hour or two
ok.. I will be working on this and would check with your for any validation or queries..
Is it a tricky one or just time consuming to set up?
tricky & would take time :-)
it needs a macro to be written
Will I be able to copy the formula to my correct wrok book?
What is the excel version you are using?
I could write the basic macro..
to select a specific row and copy it into a specific sheet
I would be improving it to suite your needs
The specifric row just need to pull through columns a-j (not the entire row)
let me finish the current macro and would modify it to bring only specific rows of interest
i mean columns a-j
I have completed this for you.click the link to download.http://ge.tt/3wvW3xz/v/0?cWhen you open your sheet you will see the populate button at the top of your main sheet.click that to run the macrobecause this is a macro, you will have to click the enable conent yellow button message that will bedirectly beneath your excel tool bar when you first open the file.it looks like the following screenshotif you do not click it, the macro will not runI wanted to see if this example works for your needs first, then I would be happy to help you copy it to your main sheet.Let me know if you have any questions, problems, or concerns.PLEASE REMEMBER TO RATE MY SERVICE, "GOOD" or "EXCELLENT" so I get reimbursed for my timeYou do so with the smiley faces beneath my ANSWER
just checking it out now
Its really really good!!! I will accept this now for this request but I have another which I will pay the same amount again or hit bonus. Give me 10min to think of the adjustments I need