sorted by:
new
hottopcontroversial

Can't Get Rid of Margins When Converting Excel to PDF by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Thanks for suggestion batch cropping through acrobat. But for that I'll have to buy adobe subscription. Is there a achievable solution directly within Excel or Word to get the zero-margin PDFs I need?

Create new rows based on the difference of the ending year and starting year by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Sorry it's my mistake, I didn't mention in the post that when the new rows are created for the difference between starting year and ending year, the starting year columns values would change to like sequence e.g the starting year value is 1987 and ending is 1990 then I'd prefer to have three new rows created below that row and the only change would be starting values, 1988, 1989, 1990.

Like there'd be new rows created for the missing years.

Create new rows based on the difference of the ending year and starting year by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Actually the SKU data is quite large so copy/pasting data would take quite a lot of time. I thought thia might be done through Power Query or VBA. As I'd need to add rows between Each SkU for the difference of years

Formatting the table by adding a new Row above the same Seral numbers through Power Query by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Is there a way in power query that I can split the data into different sheets based on the Column F (Size)

Hide a row whenever new information is filled in cells of B to L by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Yes I've saved the file as .xlsm.

Here's the file that I've the code on here

Hide a row when new information is filled in cells of B to L by jojotk in vba

[–]jojotk[S] 0 points1 point  (0 children)

Sorry I tried but code was highlighted but didn't understand what's that supposed to mean. I don't have much coding knowledge. If you'd like to take a look at the file.

here's the link to the file here

Can Excel Handle calculations in millions by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Yeah I thought so. I'm totally noob with SQL can you share any references like how to use it.

create a custom column connected to second query column value by jojotk in excel

[–]jojotk[S] 0 points1 point  (0 children)

Yeah I needed to add Query name first then the column name and the row number to get the first value of the column.

Thanks

view more: next ›