Hi All,
Newbie and lost !
I have an excel doc with numerous tabs all of which have the same data in cells k2, f21,h21,f22 & h22 which i need a macro to pull out and put onto one summary sheet.
I have found something close to what i need here but cannot get it working for my example
http://www.mrexcel.com/forum/showthread.php?t=42414
Any help greatly appreciated as i really dont want to do this manually each month cos it takes ages
Thanks,
Saz
Where in the summary sheet is the pulled data going? Does each sheet's cells go into a row in consecutive columns?
example:
3 worksheets: Summary, Sheet1, Sheet2
Summary sheet has headers from A1:E1 (5 columns, because only 5 cells - K2, F21, H21, F22, and H22 - are being pulled)
Look in Sheet1, collect those cells, put them in Summary sheet, A2:E2 (the first empty row)
Look in Sheet2, collect those cells, put them in Summary sheet, A3:E3 (next empty row).
Is that right? If not, please provide the correct information. Also, in what order should those cells' data be captured? Does K2 go in column A, F21 go in column B, etc?
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks