Hello all, I have a quick question. I have a spreadsheet that I nee
to have remain open in the background of another spreadsheet. I nee
to create a code that will take the info from a1 of the mai
spreadsheet and input it in a1 of the background spreadsheet. Th
tricky part that I can't figure out, is that if a1 on the backgroun
already has something typed in it, then I need it to put the info i
a2, so on and so forth. The background sheet is going to be updated o
a minute by minute basis.
IE.
SheetA.xls (in the background)
SheetB.xls (main screen)
MacroA takes the info from SheetB Cell A1 and puts it in SheetA Cell A
only if it's empty. If it has something in it already, then it need
to put it in SheetA Cell A2.
Any Ideas???
Thanks for all the help!
--
Message posted from
http://www.ExcelForum.com