Home » Forums » Open Source Learning Center » Question and Answer

pulling data from different sheets to one sheet

Submitted by teryn on 29 December, 2011 - 18:03

Hi,
I am trying to pull data from different sheets in a workbook. Basically I want to be able to type in a date and then have it pull the customer information for that date onto my sheet from multiple sheets. There can be different customers for that day on different sheets. I need it to pull the whole row of information for that date onto one sheet.

Thanks,
-Teryn

‹ Copy Data to other sheet with some conditions Find value, copy cell contents and paste to adjacent column (RESOLVED) ›
»
Nick's picture

 record a macro of your

Submitted by Nick on 29 December, 2011 - 18:18.

 record a macro of your actions that do what you want, and paste the code here.

excelexperts.com/Learn-VBA-Record-a-Macro

»

can't

Submitted by teryn on 29 December, 2011 - 18:30.

I looked at the video but I don't have speakers on my office computer to listen to it. I don't really understand how to acutally record a macro

-teryn

»
Nick's picture

Hi Teryn We can write

Submitted by Nick on 29 December, 2011 - 19:05.

Hi Teryn

We can write something for you for a smallish fee..

We'd need a source file, and an example of what you want to achieve.

Request a quote for more info

Nick

 

»

fee

Submitted by teryn on 29 December, 2011 - 19:12.

how much would it be...this is actually for my boss not form me so I'm not sure if he wants to pay for it

»
Nick's picture

not sure until I know exactly

Submitted by Nick on 29 December, 2011 - 22:53.

not sure until I know exactly what you're after. pls use the link above if you'd like to proceed.
tks

»

macro

Submitted by teryn on 30 December, 2011 - 16:19.

I think that I can do the macro. I figured out how to record one. I just need some advice as to how to do what I need to do. Basically from the first sheet I need to type in a date and then from other sheets in my workbook I need it to pull the whole row of information for that sheet. It is a repair schedule with different properties on different sheets. From the first sheet I want to type a date for example 12/21/2011 and have it pull the row of info from all the sheets that have a repair scheduled on that day. example date, name, phone number, address, etc. I have all of the sheets in the same format as far as the colums and what they say. I tried using a vlookup but it doesn't really work for different sheets. Once I figure this out I can do it and record the macro. I would appreciate any help.

Thanks,
-Teryn

»
Nick's picture

Hi Teryn I think you need

Submitted by Nick on 30 December, 2011 - 20:35.

Hi Teryn
I think you need more help than just this macro otherwise you will have further problems down the line. You need some advice on how best to structure your data in a way that pulling it back is easy. Happy to help, but it's more than a forum question.
Rgds
Nick

»

please contact me

Submitted by Anonymous on 3 February, 2012 - 18:52.

Hey Nick,

You had sent me a quote to me email in regards to pulling the data from different sheets. I do actually want to go ahead with it. Please contact me at my work email teryn@utbilling.com.
-Thanks,
-Teryn

»